package com.dldata.devtools30.repository.devtexcel;


import com.dldata.devtools30.entity.DevtExcelTypeEntity;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

/**

 */
@Repository
public interface DevtExcelTypeDao extends com.dldata.devtools30.repository.BaseRepository<DevtExcelTypeEntity,String>, JpaSpecificationExecutor<DevtExcelTypeEntity> {
        
        @Query("select t from DevtExcelTypeEntity t order by t.xh")
        public List<DevtExcelTypeEntity> getAllFormType();
        

        
        

        
        @Query("select t from DevtExcelTypeEntity t where t.id = ?1 order by t.xh")
        public List<DevtExcelTypeEntity> findByTypeId(String id);
        
        
        @Query("select f from DevtExcelTypeEntity f where f.id = ?1 order by f.xh ")
        public List<DevtExcelTypeEntity> getFormByTypeId(String id);


        @Query("select f from DevtExcelTypeEntity f where f.xh = ?1 order by f.xh ")
        public List<DevtExcelTypeEntity> findByXh(Integer xh);
}
